◀ Prev · Parts · Full · Next ▶

layout: Wide · Narrow · Centered

SQL Server Compact shares a common API with the other Microsoft SQL Server editions.cite-ref-lap1-4-0[4] It also includes ADO.NET providers for data access using ADO.NET APIs, and built-in synchronization capabilities,cite-ref-datasheet-2-2[2] as well as support for LINQ and Entity Framework. Future releases will unify the synchronization capabilities with Microsoft Synchronization Services.cite-ref-jad-5-0[5] Unlike other editions of Microsoft SQL Server, SQL CE runs in-processcite-ref-jad-5-1[5] with the application which is hosting it. It has a disk footprint of less than 2 MB and a memory footprint of approximately 5 MB.cite-ref-datasheet-2-3[2] SQL CE is optimized for an architecture where all applications share the same memory pool.cite-ref-new-6-0[6] Windows Store apps for Windows 8 cannot use SQL Server Compact edition, or any other edition of SQL Server.cite-ref-nossceonrt-7-0[7]

| Official name | Common name | Release date | Support date |

|---|---|---|---|

| SQL Server 2000 Windows CE Edition SQL… | SQL CE 1.0 | 2000-10-26 | |

| SQL Server 2000 Windows CE Edition 1.1… | SQL CE 1.1 | 2001-03-21 | |

| SQL Server 2000 Windows CE Edition 2.0… | SQL CE 2.0 | 2002-09-16 | |

| SQL Server 2005 Mobile Edition | SQL CE 3.0 | 2006-01-14 | |

| SQL Server 2005 Compact Edition | SQL CE 3.1 | 2007-02-19 | 2016-04-12 |

| SQL Server Compact 3.5 | SQL CE 3.5 | 2008-02-19 | 2018-04-10 |

| SQL Server Compact 4.0 | SQL CE 4.0 | 2011-04-13 | 2021-07-13 |

◀ Prev · Parts · Full · Next ▶